{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/baconbaker/anaconda3/envs/ml/lib/python3.8/site-packages/sklearn/utils/deprecation.py:143: FutureWarning: The sklearn.cluster.dbscan_ module is  deprecated in version 0.22 and will be removed in version 0.24. The corresponding classes / functions should instead be imported from sklearn.cluster. Anything that cannot be imported from sklearn.cluster is now part of the private API.\n",
      "  warnings.warn(message, FutureWarning)\n"
     ]
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "\n",
    "import os\n",
    "import datetime\n",
    "\n",
    "import preprocessing_rocka\n",
    "import baseline_extraction\n",
    "import shape_based_distance\n",
    "import density_estimation\n",
    "import model"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [],
   "source": [
    "PATH = '../../../../data/train_data/host/'\n",
    "files = [PATH + f for f in os.listdir(PATH)]\n",
    "df = pd.concat([pd.read_csv(f) for f in files])\n",
    "\n",
    "df_inf = pd.read_csv('../kpi_summary_info.data')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 149,
   "metadata": {},
   "outputs": [
    {
     "ename": "SyntaxError",
     "evalue": "unexpected EOF while parsing (<ipython-input-149-7236762f2e70>, line 27)",
     "output_type": "error",
     "traceback": [
      "\u001b[0;36m  File \u001b[0;32m\"<ipython-input-149-7236762f2e70>\"\u001b[0;36m, line \u001b[0;32m27\u001b[0m\n\u001b[0;31m    for host in hosts:\u001b[0m\n\u001b[0m                      ^\u001b[0m\n\u001b[0;31mSyntaxError\u001b[0m\u001b[0;31m:\u001b[0m unexpected EOF while parsing\n"
     ]
    }
   ],
   "source": [
    "def remove_flat(df, df_info):\n",
    "    flat_kpis = df_info[(df_info.is_flat == True)]['kpi'].unique()\n",
    "    df = df[~df.name.isin(flat_kpis)]\n",
    "    return df\n",
    "\n",
    "def get_timestamps(df, interval):\n",
    "    curr_time = np.max(df['timestamp'])\n",
    "    timestamps = [curr_time - x*(interval*1000*60) for x in range(int(60*24/(interval)))]\n",
    "    return timestamps\n",
    "    \n",
    "def split_freq(df, df_info):\n",
    "    min1_kpis = df_info[(df_info.interval == '1min')]['kpi'].unique()\n",
    "    min5_kpis = df_info[(df_info.interval == '5min')]['kpi'].unique()\n",
    "    \n",
    "    df_1min = df[df.name.isin(min1_kpis)]\n",
    "    df_5min = df[df.name.isin(min5_kpis)]\n",
    "    \n",
    "    return df_1min, df_5min\n",
    "\n",
    "def handle_intervals(df, interval):\n",
    "    df.resample(str(interval)+'T').sum()\n",
    "    print(df.head())\n",
    "    return df\n",
    "\n",
    "def stuffing(df, interval):\n",
    "    out_df = pd.DataFrame(columns=list(df.columns))\n",
    "    hosts = df.cmdb_id.unique()\n",
    "    for host in hosts:\n",
    "        df_h = df[df.cmdb_id == host]\n",
    "        for name in df_h.name.unique():\n",
    "            df_hn = df_h[df_h.name == name]\n",
    "            df_hn = handle_intervals(df_hn, interval)\n",
    "            df_hn\n",
    "            "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 148,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "<ipython-input-148-5530274e49e9>:4: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  df1['timestamp'] = df1['timestamp'].apply(lambda x: datetime.datetime.fromtimestamp(x/1000.))\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                              itemid                      name     bomc_id  \\\n",
      "timestamp                                                                    \n",
      "2020-05-03 18:00:00  999999996432300          Num_of_processes  ZJ-001-076   \n",
      "2020-05-03 18:00:01  999999996432301            Zombie_Process  ZJ-001-126   \n",
      "2020-05-03 18:00:02  999999996432302  Num_of_running_processes  ZJ-001-075   \n",
      "2020-05-03 18:00:02  999999996430202             Shared_memory  ZJ-001-016   \n",
      "2020-05-03 18:00:03  999999996487803  System_wait_queue_length  ZJ-001-078   \n",
      "...                              ...                       ...         ...   \n",
      "2020-05-04 17:59:57         63309297              Sent_packets  ZJ-001-071   \n",
      "2020-05-04 17:59:58         63309298              Sent_packets  ZJ-001-071   \n",
      "2020-05-04 17:59:58  999999996482098                Sent_queue  ZJ-001-064   \n",
      "2020-05-04 17:59:59         63309299              Sent_packets  ZJ-001-071   \n",
      "2020-05-04 17:59:59  999999996482099            Received_queue  ZJ-001-063   \n",
      "\n",
      "                     value cmdb_id  \n",
      "timestamp                           \n",
      "2020-05-03 18:00:00  223.0  os_009  \n",
      "2020-05-03 18:00:01    0.0  os_009  \n",
      "2020-05-03 18:00:02    4.0  os_009  \n",
      "2020-05-03 18:00:02    0.0  os_022  \n",
      "2020-05-03 18:00:03    0.0  os_017  \n",
      "...                    ...     ...  \n",
      "2020-05-04 17:59:57   59.0  os_012  \n",
      "2020-05-04 17:59:58    0.0  os_012  \n",
      "2020-05-04 17:59:58    1.0  os_020  \n",
      "2020-05-04 17:59:59    0.0  os_012  \n",
      "2020-05-04 17:59:59    0.0  os_020  \n",
      "\n",
      "[132768 rows x 5 columns]\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "<ipython-input-148-5530274e49e9>:8: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  df5['timestamp'] = df5['timestamp'].apply(lambda x: datetime.datetime.fromtimestamp(x/1000.))\n"
     ]
    }
   ],
   "source": [
    "df_x = remove_flat(df, df_inf)\n",
    "df1, df5 = split_freq(df_x, df_inf)\n",
    "\n",
    "df1['timestamp'] = df1['timestamp'].apply(lambda x: datetime.datetime.fromtimestamp(x/1000.))\n",
    "hosts = df1['cmdb_id'].unique()\n",
    "\n",
    "    \n",
    "df1 = df1.set_index('timestamp').sort_values('timestamp')\n",
    "\n",
    "df5['timestamp'] = df5['timestamp'].apply(lambda x: datetime.datetime.fromtimestamp(x/1000.))\n",
    "df5 = df5.set_index('timestamp').sort_values('timestamp')\n",
    "\n",
    "df5.resample('5T')\n",
    "\n",
    "print(df5)\n",
    "df1 = df1[['cmdb_id','name','value']].groupby(['cmdb_id', 'name'])\n",
    "df5 = df5[['cmdb_id','name','value']].groupby(['cmdb_id','name'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 122,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "dict_keys([('db_001', 'ACS'), ('db_001', 'AIOS'), ('db_001', 'AWS'), ('db_001', 'CPU_Used_Pct'), ('db_001', 'CPU_free_pct'), ('db_001', 'Call_Per_Sec'), ('db_001', 'DFParaWrite_Per_Sec'), ('db_001', 'DbTime'), ('db_001', 'Exec_Per_Sec'), ('db_001', 'LFParaWrite_Per_Sec'), ('db_001', 'LFSync_Per_Sec'), ('db_001', 'Logic_Read_Per_Sec'), ('db_001', 'Login_Per_Sec'), ('db_001', 'MEM_Total'), ('db_001', 'MEM_Used'), ('db_001', 'MEM_Used_Pct'), ('db_001', 'MEM_real_util'), ('db_001', 'New_Tbs_Free_Gb'), ('db_001', 'New_Tbs_Used_Pct'), ('db_001', 'Physical_Read_Per_Sec'), ('db_001', 'Proc_Used_Pct'), ('db_001', 'Proc_User_Used_Pct'), ('db_001', 'Redo_Per_Sec'), ('db_001', 'SctRead_Per_Sec'), ('db_001', 'SeqRead_Per_Sec'), ('db_001', 'Sess_Active'), ('db_001', 'Sess_Connect'), ('db_001', 'Session_pct'), ('db_001', 'TPS_Per_Sec'), ('db_001', 'User_Commit'), ('db_001', 'tnsping_result_time'), ('db_002', 'ACS'), ('db_002', 'AIOS'), ('db_002', 'AWS'), ('db_002', 'CPU_Used_Pct'), ('db_002', 'CPU_free_pct'), ('db_002', 'Call_Per_Sec'), ('db_002', 'DFParaWrite_Per_Sec'), ('db_002', 'DbTime'), ('db_002', 'Exec_Per_Sec'), ('db_002', 'LFParaWrite_Per_Sec'), ('db_002', 'LFSync_Per_Sec'), ('db_002', 'Logic_Read_Per_Sec'), ('db_002', 'Login_Per_Sec'), ('db_002', 'MEM_Total'), ('db_002', 'MEM_Used'), ('db_002', 'MEM_Used_Pct'), ('db_002', 'MEM_real_util'), ('db_002', 'New_Tbs_Free_Gb'), ('db_002', 'New_Tbs_Used_Pct'), ('db_002', 'Physical_Read_Per_Sec'), ('db_002', 'Proc_Used_Pct'), ('db_002', 'Proc_User_Used_Pct'), ('db_002', 'Redo_Per_Sec'), ('db_002', 'SctRead_Per_Sec'), ('db_002', 'SeqRead_Per_Sec'), ('db_002', 'Sess_Active'), ('db_002', 'Sess_Connect'), ('db_002', 'Session_pct'), ('db_002', 'TPS_Per_Sec'), ('db_002', 'User_Commit'), ('db_002', 'tnsping_result_time'), ('db_003', 'ACS'), ('db_003', 'AIOS'), ('db_003', 'AWS'), ('db_003', 'CPU_Used_Pct'), ('db_003', 'CPU_free_pct'), ('db_003', 'Call_Per_Sec'), ('db_003', 'DFParaWrite_Per_Sec'), ('db_003', 'DbTime'), ('db_003', 'Exec_Per_Sec'), ('db_003', 'LFParaWrite_Per_Sec'), ('db_003', 'LFSync_Per_Sec'), ('db_003', 'Logic_Read_Per_Sec'), ('db_003', 'Login_Per_Sec'), ('db_003', 'MEM_Total'), ('db_003', 'MEM_Used'), ('db_003', 'MEM_Used_Pct'), ('db_003', 'MEM_real_util'), ('db_003', 'New_Tbs_Free_Gb'), ('db_003', 'New_Tbs_Used_Pct'), ('db_003', 'Physical_Read_Per_Sec'), ('db_003', 'Proc_Used_Pct'), ('db_003', 'Proc_User_Used_Pct'), ('db_003', 'Redo_Per_Sec'), ('db_003', 'SctRead_Per_Sec'), ('db_003', 'SeqRead_Per_Sec'), ('db_003', 'Sess_Active'), ('db_003', 'Sess_Connect'), ('db_003', 'Session_pct'), ('db_003', 'TPS_Per_Sec'), ('db_003', 'User_Commit'), ('db_003', 'tnsping_result_time'), ('db_004', 'ACS'), ('db_004', 'AIOS'), ('db_004', 'AWS'), ('db_004', 'CPU_Used_Pct'), ('db_004', 'CPU_free_pct'), ('db_004', 'Call_Per_Sec'), ('db_004', 'DFParaWrite_Per_Sec'), ('db_004', 'DbTime'), ('db_004', 'Exec_Per_Sec'), ('db_004', 'LFParaWrite_Per_Sec'), ('db_004', 'LFSync_Per_Sec'), ('db_004', 'Logic_Read_Per_Sec'), ('db_004', 'Login_Per_Sec'), ('db_004', 'MEM_Total'), ('db_004', 'MEM_Used'), ('db_004', 'MEM_Used_Pct'), ('db_004', 'MEM_real_util'), ('db_004', 'New_Tbs_Free_Gb'), ('db_004', 'New_Tbs_Used_Pct'), ('db_004', 'Physical_Read_Per_Sec'), ('db_004', 'Proc_Used_Pct'), ('db_004', 'Proc_User_Used_Pct'), ('db_004', 'Redo_Per_Sec'), ('db_004', 'SctRead_Per_Sec'), ('db_004', 'SeqRead_Per_Sec'), ('db_004', 'Sess_Active'), ('db_004', 'Sess_Connect'), ('db_004', 'Session_pct'), ('db_004', 'TPS_Per_Sec'), ('db_004', 'User_Commit'), ('db_004', 'tnsping_result_time'), ('db_005', 'ACS'), ('db_005', 'AIOS'), ('db_005', 'AWS'), ('db_005', 'CPU_Used_Pct'), ('db_005', 'CPU_free_pct'), ('db_005', 'Call_Per_Sec'), ('db_005', 'DFParaWrite_Per_Sec'), ('db_005', 'DbTime'), ('db_005', 'Exec_Per_Sec'), ('db_005', 'LFParaWrite_Per_Sec'), ('db_005', 'LFSync_Per_Sec'), ('db_005', 'Logic_Read_Per_Sec'), ('db_005', 'Login_Per_Sec'), ('db_005', 'MEM_Total'), ('db_005', 'MEM_Used'), ('db_005', 'MEM_Used_Pct'), ('db_005', 'MEM_real_util'), ('db_005', 'New_Tbs_Free_Gb'), ('db_005', 'New_Tbs_Used_Pct'), ('db_005', 'Physical_Read_Per_Sec'), ('db_005', 'Proc_Used_Pct'), ('db_005', 'Proc_User_Used_Pct'), ('db_005', 'Redo_Per_Sec'), ('db_005', 'SctRead_Per_Sec'), ('db_005', 'SeqRead_Per_Sec'), ('db_005', 'Sess_Active'), ('db_005', 'Sess_Connect'), ('db_005', 'Session_pct'), ('db_005', 'TPS_Per_Sec'), ('db_005', 'User_Commit'), ('db_005', 'tnsping_result_time'), ('db_006', 'ACS'), ('db_006', 'AIOS'), ('db_006', 'AWS'), ('db_006', 'CPU_Used_Pct'), ('db_006', 'CPU_free_pct'), ('db_006', 'Call_Per_Sec'), ('db_006', 'DFParaWrite_Per_Sec'), ('db_006', 'DbTime'), ('db_006', 'Exec_Per_Sec'), ('db_006', 'LFParaWrite_Per_Sec'), ('db_006', 'LFSync_Per_Sec'), ('db_006', 'Logic_Read_Per_Sec'), ('db_006', 'Login_Per_Sec'), ('db_006', 'MEM_Total'), ('db_006', 'MEM_Used'), ('db_006', 'MEM_Used_Pct'), ('db_006', 'MEM_real_util'), ('db_006', 'New_Tbs_Free_Gb'), ('db_006', 'New_Tbs_Used_Pct'), ('db_006', 'Physical_Read_Per_Sec'), ('db_006', 'Proc_Used_Pct'), ('db_006', 'Proc_User_Used_Pct'), ('db_006', 'Redo_Per_Sec'), ('db_006', 'SctRead_Per_Sec'), ('db_006', 'SeqRead_Per_Sec'), ('db_006', 'Sess_Active'), ('db_006', 'Sess_Connect'), ('db_006', 'Session_pct'), ('db_006', 'TPS_Per_Sec'), ('db_006', 'User_Commit'), ('db_006', 'tnsping_result_time'), ('db_007', 'ACS'), ('db_007', 'AIOS'), ('db_007', 'AWS'), ('db_007', 'CPU_Used_Pct'), ('db_007', 'CPU_free_pct'), ('db_007', 'Call_Per_Sec'), ('db_007', 'DFParaWrite_Per_Sec'), ('db_007', 'DbTime'), ('db_007', 'Exec_Per_Sec'), ('db_007', 'LFParaWrite_Per_Sec'), ('db_007', 'LFSync_Per_Sec'), ('db_007', 'Logic_Read_Per_Sec'), ('db_007', 'Login_Per_Sec'), ('db_007', 'MEM_Total'), ('db_007', 'MEM_Used'), ('db_007', 'MEM_Used_Pct'), ('db_007', 'MEM_real_util'), ('db_007', 'New_Tbs_Free_Gb'), ('db_007', 'New_Tbs_Used_Pct'), ('db_007', 'Physical_Read_Per_Sec'), ('db_007', 'Proc_Used_Pct'), ('db_007', 'Proc_User_Used_Pct'), ('db_007', 'Redo_Per_Sec'), ('db_007', 'SctRead_Per_Sec'), ('db_007', 'SeqRead_Per_Sec'), ('db_007', 'Sess_Active'), ('db_007', 'Sess_Connect'), ('db_007', 'Session_pct'), ('db_007', 'TPS_Per_Sec'), ('db_007', 'User_Commit'), ('db_007', 'tnsping_result_time'), ('db_008', 'ACS'), ('db_008', 'AIOS'), ('db_008', 'AWS'), ('db_008', 'CPU_Used_Pct'), ('db_008', 'CPU_free_pct'), ('db_008', 'Call_Per_Sec'), ('db_008', 'DFParaWrite_Per_Sec'), ('db_008', 'DbTime'), ('db_008', 'Exec_Per_Sec'), ('db_008', 'LFParaWrite_Per_Sec'), ('db_008', 'LFSync_Per_Sec'), ('db_008', 'Logic_Read_Per_Sec'), ('db_008', 'Login_Per_Sec'), ('db_008', 'MEM_Total'), ('db_008', 'MEM_Used'), ('db_008', 'MEM_Used_Pct'), ('db_008', 'MEM_real_util'), ('db_008', 'New_Tbs_Free_Gb'), ('db_008', 'New_Tbs_Used_Pct'), ('db_008', 'Physical_Read_Per_Sec'), ('db_008', 'Proc_Used_Pct'), ('db_008', 'Proc_User_Used_Pct'), ('db_008', 'Redo_Per_Sec'), ('db_008', 'SctRead_Per_Sec'), ('db_008', 'SeqRead_Per_Sec'), ('db_008', 'Sess_Active'), ('db_008', 'Sess_Connect'), ('db_008', 'Session_pct'), ('db_008', 'TPS_Per_Sec'), ('db_008', 'User_Commit'), ('db_008', 'tnsping_result_time'), ('db_009', 'ACS'), ('db_009', 'AIOS'), ('db_009', 'AWS'), ('db_009', 'CPU_Used_Pct'), ('db_009', 'CPU_free_pct'), ('db_009', 'Call_Per_Sec'), ('db_009', 'DFParaWrite_Per_Sec'), ('db_009', 'DbTime'), ('db_009', 'Exec_Per_Sec'), ('db_009', 'LFParaWrite_Per_Sec'), ('db_009', 'LFSync_Per_Sec'), ('db_009', 'Logic_Read_Per_Sec'), ('db_009', 'Login_Per_Sec'), ('db_009', 'MEM_Total'), ('db_009', 'MEM_Used'), ('db_009', 'MEM_Used_Pct'), ('db_009', 'MEM_real_util'), ('db_009', 'New_Tbs_Free_Gb'), ('db_009', 'New_Tbs_Used_Pct'), ('db_009', 'Physical_Read_Per_Sec'), ('db_009', 'Proc_Used_Pct'), ('db_009', 'Proc_User_Used_Pct'), ('db_009', 'Redo_Per_Sec'), ('db_009', 'SctRead_Per_Sec'), ('db_009', 'SeqRead_Per_Sec'), ('db_009', 'Sess_Active'), ('db_009', 'Sess_Connect'), ('db_009', 'Session_pct'), ('db_009', 'TPS_Per_Sec'), ('db_009', 'User_Commit'), ('db_009', 'tnsping_result_time'), ('db_010', 'ACS'), ('db_010', 'AIOS'), ('db_010', 'AWS'), ('db_010', 'CPU_Used_Pct'), ('db_010', 'CPU_free_pct'), ('db_010', 'Call_Per_Sec'), ('db_010', 'DFParaWrite_Per_Sec'), ('db_010', 'DbTime'), ('db_010', 'Exec_Per_Sec'), ('db_010', 'LFParaWrite_Per_Sec'), ('db_010', 'LFSync_Per_Sec'), ('db_010', 'Logic_Read_Per_Sec'), ('db_010', 'Login_Per_Sec'), ('db_010', 'MEM_Total'), ('db_010', 'MEM_Used'), ('db_010', 'MEM_Used_Pct'), ('db_010', 'MEM_real_util'), ('db_010', 'New_Tbs_Free_Gb'), ('db_010', 'New_Tbs_Used_Pct'), ('db_010', 'Physical_Read_Per_Sec'), ('db_010', 'Proc_Used_Pct'), ('db_010', 'Proc_User_Used_Pct'), ('db_010', 'Redo_Per_Sec'), ('db_010', 'SctRead_Per_Sec'), ('db_010', 'SeqRead_Per_Sec'), ('db_010', 'Sess_Active'), ('db_010', 'Sess_Connect'), ('db_010', 'Session_pct'), ('db_010', 'TPS_Per_Sec'), ('db_010', 'User_Commit'), ('db_010', 'tnsping_result_time'), ('db_011', 'ACS'), ('db_011', 'AIOS'), ('db_011', 'AWS'), ('db_011', 'CPU_Used_Pct'), ('db_011', 'CPU_free_pct'), ('db_011', 'Call_Per_Sec'), ('db_011', 'DFParaWrite_Per_Sec'), ('db_011', 'DbTime'), ('db_011', 'Exec_Per_Sec'), ('db_011', 'LFParaWrite_Per_Sec'), ('db_011', 'LFSync_Per_Sec'), ('db_011', 'Logic_Read_Per_Sec'), ('db_011', 'Login_Per_Sec'), ('db_011', 'MEM_Total'), ('db_011', 'MEM_Used'), ('db_011', 'MEM_Used_Pct'), ('db_011', 'MEM_real_util'), ('db_011', 'New_Tbs_Free_Gb'), ('db_011', 'New_Tbs_Used_Pct'), ('db_011', 'Physical_Read_Per_Sec'), ('db_011', 'Proc_Used_Pct'), ('db_011', 'Proc_User_Used_Pct'), ('db_011', 'Redo_Per_Sec'), ('db_011', 'SctRead_Per_Sec'), ('db_011', 'SeqRead_Per_Sec'), ('db_011', 'Sess_Active'), ('db_011', 'Sess_Connect'), ('db_011', 'Session_pct'), ('db_011', 'TPS_Per_Sec'), ('db_011', 'User_Commit'), ('db_011', 'tnsping_result_time'), ('db_012', 'ACS'), ('db_012', 'AIOS'), ('db_012', 'AWS'), ('db_012', 'CPU_Used_Pct'), ('db_012', 'CPU_free_pct'), ('db_012', 'Call_Per_Sec'), ('db_012', 'DFParaWrite_Per_Sec'), ('db_012', 'DbTime'), ('db_012', 'Exec_Per_Sec'), ('db_012', 'LFParaWrite_Per_Sec'), ('db_012', 'LFSync_Per_Sec'), ('db_012', 'Logic_Read_Per_Sec'), ('db_012', 'Login_Per_Sec'), ('db_012', 'MEM_Total'), ('db_012', 'MEM_Used'), ('db_012', 'MEM_Used_Pct'), ('db_012', 'MEM_real_util'), ('db_012', 'New_Tbs_Free_Gb'), ('db_012', 'New_Tbs_Used_Pct'), ('db_012', 'Physical_Read_Per_Sec'), ('db_012', 'Proc_Used_Pct'), ('db_012', 'Proc_User_Used_Pct'), ('db_012', 'Redo_Per_Sec'), ('db_012', 'SctRead_Per_Sec'), ('db_012', 'SeqRead_Per_Sec'), ('db_012', 'Sess_Active'), ('db_012', 'Sess_Connect'), ('db_012', 'Session_pct'), ('db_012', 'TPS_Per_Sec'), ('db_012', 'User_Commit'), ('db_012', 'tnsping_result_time'), ('db_013', 'ACS'), ('db_013', 'AIOS'), ('db_013', 'AWS'), ('db_013', 'CPU_Used_Pct'), ('db_013', 'CPU_free_pct'), ('db_013', 'Call_Per_Sec'), ('db_013', 'DFParaWrite_Per_Sec'), ('db_013', 'DbTime'), ('db_013', 'Exec_Per_Sec'), ('db_013', 'LFParaWrite_Per_Sec'), ('db_013', 'LFSync_Per_Sec'), ('db_013', 'Logic_Read_Per_Sec'), ('db_013', 'Login_Per_Sec'), ('db_013', 'MEM_Total'), ('db_013', 'MEM_Used'), ('db_013', 'MEM_Used_Pct'), ('db_013', 'MEM_real_util'), ('db_013', 'New_Tbs_Free_Gb'), ('db_013', 'New_Tbs_Used_Pct'), ('db_013', 'Physical_Read_Per_Sec'), ('db_013', 'Proc_Used_Pct'), ('db_013', 'Proc_User_Used_Pct'), ('db_013', 'Redo_Per_Sec'), ('db_013', 'SctRead_Per_Sec'), ('db_013', 'SeqRead_Per_Sec'), ('db_013', 'Sess_Active'), ('db_013', 'Sess_Connect'), ('db_013', 'Session_pct'), ('db_013', 'TPS_Per_Sec'), ('db_013', 'User_Commit'), ('db_013', 'tnsping_result_time'), ('docker_001', 'container_cpu_used'), ('docker_001', 'container_mem_used'), ('docker_002', 'container_cpu_used'), ('docker_002', 'container_mem_used'), ('docker_003', 'container_cpu_used'), ('docker_003', 'container_mem_used'), ('docker_004', 'container_cpu_used'), ('docker_004', 'container_mem_used'), ('docker_005', 'container_cpu_used'), ('docker_005', 'container_mem_used'), ('docker_006', 'container_cpu_used'), ('docker_006', 'container_mem_used'), ('docker_007', 'container_cpu_used'), ('docker_007', 'container_mem_used'), ('docker_008', 'container_cpu_used'), ('docker_008', 'container_mem_used'), ('os_001', 'CPU_idle_pct'), ('os_001', 'CPU_iowait_time'), ('os_001', 'CPU_system_time'), ('os_001', 'CPU_user_time'), ('os_001', 'CPU_util_pct'), ('os_001', 'Disk_avgqu_sz'), ('os_001', 'Disk_await'), ('os_001', 'Disk_io_util'), ('os_001', 'Disk_rd_ios'), ('os_001', 'Disk_rd_kbs'), ('os_001', 'Disk_svctm'), ('os_001', 'Disk_wr_ios'), ('os_001', 'Disk_wr_kbs'), ('os_001', 'Incoming_network_traffic'), ('os_001', 'Memory_available'), ('os_001', 'Memory_available_pct'), ('os_001', 'Memory_used'), ('os_001', 'Memory_used_pct'), ('os_001', 'Outgoing_network_traffic'), ('os_001', 'Page_pi'), ('os_001', 'Page_po'), ('os_001', 'Processor_load_15_min'), ('os_001', 'Processor_load_1_min'), ('os_001', 'Processor_load_5_min'), ('os_001', 'Recv_total'), ('os_001', 'Send_total'), ('os_001', 'ss_total'), ('os_002', 'CPU_idle_pct'), ('os_002', 'CPU_iowait_time'), ('os_002', 'CPU_system_time'), ('os_002', 'CPU_user_time'), ('os_002', 'CPU_util_pct'), ('os_002', 'Disk_avgqu_sz'), ('os_002', 'Disk_await'), ('os_002', 'Disk_io_util'), ('os_002', 'Disk_rd_ios'), ('os_002', 'Disk_rd_kbs'), ('os_002', 'Disk_svctm'), ('os_002', 'Disk_wr_ios'), ('os_002', 'Disk_wr_kbs'), ('os_002', 'Incoming_network_traffic'), ('os_002', 'Memory_available'), ('os_002', 'Memory_available_pct'), ('os_002', 'Memory_used'), ('os_002', 'Memory_used_pct'), ('os_002', 'Outgoing_network_traffic'), ('os_002', 'Page_pi'), ('os_002', 'Page_po'), ('os_002', 'Processor_load_15_min'), ('os_002', 'Processor_load_1_min'), ('os_002', 'Processor_load_5_min'), ('os_002', 'Recv_total'), ('os_002', 'Send_total'), ('os_002', 'ss_total'), ('os_003', 'CPU_idle_pct'), ('os_003', 'CPU_iowait_time'), ('os_003', 'CPU_system_time'), ('os_003', 'CPU_user_time'), ('os_003', 'CPU_util_pct'), ('os_003', 'Disk_avgqu_sz'), ('os_003', 'Disk_await'), ('os_003', 'Disk_io_util'), ('os_003', 'Disk_rd_ios'), ('os_003', 'Disk_rd_kbs'), ('os_003', 'Disk_svctm'), ('os_003', 'Disk_wr_ios'), ('os_003', 'Disk_wr_kbs'), ('os_003', 'Incoming_network_traffic'), ('os_003', 'Memory_available'), ('os_003', 'Memory_available_pct'), ('os_003', 'Memory_used'), ('os_003', 'Memory_used_pct'), ('os_003', 'Outgoing_network_traffic'), ('os_003', 'Page_pi'), ('os_003', 'Page_po'), ('os_003', 'Processor_load_15_min'), ('os_003', 'Processor_load_1_min'), ('os_003', 'Processor_load_5_min'), ('os_003', 'Recv_total'), ('os_003', 'Send_total'), ('os_003', 'ss_total'), ('os_004', 'CPU_idle_pct'), ('os_004', 'CPU_iowait_time'), ('os_004', 'CPU_system_time'), ('os_004', 'CPU_user_time'), ('os_004', 'CPU_util_pct'), ('os_004', 'Disk_avgqu_sz'), ('os_004', 'Disk_await'), ('os_004', 'Disk_io_util'), ('os_004', 'Disk_rd_ios'), ('os_004', 'Disk_rd_kbs'), ('os_004', 'Disk_svctm'), ('os_004', 'Disk_wr_ios'), ('os_004', 'Disk_wr_kbs'), ('os_004', 'Incoming_network_traffic'), ('os_004', 'Memory_available'), ('os_004', 'Memory_available_pct'), ('os_004', 'Memory_used'), ('os_004', 'Memory_used_pct'), ('os_004', 'Outgoing_network_traffic'), ('os_004', 'Page_pi'), ('os_004', 'Page_po'), ('os_004', 'Processor_load_15_min'), ('os_004', 'Processor_load_1_min'), ('os_004', 'Processor_load_5_min'), ('os_004', 'Recv_total'), ('os_004', 'Send_total'), ('os_004', 'ss_total'), ('os_005', 'CPU_idle_pct'), ('os_005', 'CPU_iowait_time'), ('os_005', 'CPU_system_time'), ('os_005', 'CPU_user_time'), ('os_005', 'CPU_util_pct'), ('os_005', 'Disk_avgqu_sz'), ('os_005', 'Disk_await'), ('os_005', 'Disk_io_util'), ('os_005', 'Disk_rd_ios'), ('os_005', 'Disk_rd_kbs'), ('os_005', 'Disk_svctm'), ('os_005', 'Disk_wr_ios'), ('os_005', 'Disk_wr_kbs'), ('os_005', 'Incoming_network_traffic'), ('os_005', 'Memory_available'), ('os_005', 'Memory_available_pct'), ('os_005', 'Memory_used'), ('os_005', 'Memory_used_pct'), ('os_005', 'Outgoing_network_traffic'), ('os_005', 'Page_pi'), ('os_005', 'Page_po'), ('os_005', 'Processor_load_15_min'), ('os_005', 'Processor_load_1_min'), ('os_005', 'Processor_load_5_min'), ('os_005', 'Recv_total'), ('os_005', 'Send_total'), ('os_005', 'ss_total'), ('os_006', 'CPU_idle_pct'), ('os_006', 'CPU_iowait_time'), ('os_006', 'CPU_system_time'), ('os_006', 'CPU_user_time'), ('os_006', 'CPU_util_pct'), ('os_006', 'Disk_avgqu_sz'), ('os_006', 'Disk_await'), ('os_006', 'Disk_io_util'), ('os_006', 'Disk_rd_ios'), ('os_006', 'Disk_rd_kbs'), ('os_006', 'Disk_svctm'), ('os_006', 'Disk_wr_ios'), ('os_006', 'Disk_wr_kbs'), ('os_006', 'Incoming_network_traffic'), ('os_006', 'Memory_available'), ('os_006', 'Memory_available_pct'), ('os_006', 'Memory_used'), ('os_006', 'Memory_used_pct'), ('os_006', 'Outgoing_network_traffic'), ('os_006', 'Page_pi'), ('os_006', 'Page_po'), ('os_006', 'Processor_load_15_min'), ('os_006', 'Processor_load_1_min'), ('os_006', 'Processor_load_5_min'), ('os_006', 'Recv_total'), ('os_006', 'Send_total'), ('os_006', 'ss_total'), ('os_007', 'CPU_idle_pct'), ('os_007', 'CPU_iowait_time'), ('os_007', 'CPU_system_time'), ('os_007', 'CPU_user_time'), ('os_007', 'CPU_util_pct'), ('os_007', 'Disk_avgqu_sz'), ('os_007', 'Disk_await'), ('os_007', 'Disk_io_util'), ('os_007', 'Disk_rd_ios'), ('os_007', 'Disk_rd_kbs'), ('os_007', 'Disk_svctm'), ('os_007', 'Disk_wr_ios'), ('os_007', 'Disk_wr_kbs'), ('os_007', 'Incoming_network_traffic'), ('os_007', 'Memory_available'), ('os_007', 'Memory_available_pct'), ('os_007', 'Memory_used'), ('os_007', 'Memory_used_pct'), ('os_007', 'Outgoing_network_traffic'), ('os_007', 'Page_pi'), ('os_007', 'Page_po'), ('os_007', 'Processor_load_15_min'), ('os_007', 'Processor_load_1_min'), ('os_007', 'Processor_load_5_min'), ('os_007', 'Recv_total'), ('os_007', 'Send_total'), ('os_007', 'ss_total'), ('os_008', 'CPU_idle_pct'), ('os_008', 'CPU_iowait_time'), ('os_008', 'CPU_system_time'), ('os_008', 'CPU_user_time'), ('os_008', 'CPU_util_pct'), ('os_008', 'Disk_avgqu_sz'), ('os_008', 'Disk_await'), ('os_008', 'Disk_io_util'), ('os_008', 'Disk_rd_ios'), ('os_008', 'Disk_rd_kbs'), ('os_008', 'Disk_svctm'), ('os_008', 'Disk_wr_ios'), ('os_008', 'Disk_wr_kbs'), ('os_008', 'Incoming_network_traffic'), ('os_008', 'Memory_available'), ('os_008', 'Memory_available_pct'), ('os_008', 'Memory_used'), ('os_008', 'Memory_used_pct'), ('os_008', 'Outgoing_network_traffic'), ('os_008', 'Page_pi'), ('os_008', 'Page_po'), ('os_008', 'Processor_load_15_min'), ('os_008', 'Processor_load_1_min'), ('os_008', 'Processor_load_5_min'), ('os_008', 'Recv_total'), ('os_008', 'Send_total'), ('os_008', 'ss_total'), ('os_009', 'CPU_idle_pct'), ('os_009', 'CPU_iowait_time'), ('os_009', 'CPU_system_time'), ('os_009', 'CPU_user_time'), ('os_009', 'CPU_util_pct'), ('os_009', 'Disk_avgqu_sz'), ('os_009', 'Disk_await'), ('os_009', 'Disk_io_util'), ('os_009', 'Disk_rd_ios'), ('os_009', 'Disk_rd_kbs'), ('os_009', 'Disk_svctm'), ('os_009', 'Disk_wr_ios'), ('os_009', 'Disk_wr_kbs'), ('os_009', 'Incoming_network_traffic'), ('os_009', 'Memory_available'), ('os_009', 'Memory_available_pct'), ('os_009', 'Memory_used'), ('os_009', 'Memory_used_pct'), ('os_009', 'Outgoing_network_traffic'), ('os_009', 'Page_pi'), ('os_009', 'Page_po'), ('os_009', 'Processor_load_15_min'), ('os_009', 'Processor_load_1_min'), ('os_009', 'Processor_load_5_min'), ('os_009', 'Recv_total'), ('os_009', 'Send_total'), ('os_009', 'ss_total'), ('os_010', 'CPU_idle_pct'), ('os_010', 'CPU_iowait_time'), ('os_010', 'CPU_system_time'), ('os_010', 'CPU_user_time'), ('os_010', 'CPU_util_pct'), ('os_010', 'Disk_avgqu_sz'), ('os_010', 'Disk_await'), ('os_010', 'Disk_io_util'), ('os_010', 'Disk_rd_ios'), ('os_010', 'Disk_rd_kbs'), ('os_010', 'Disk_svctm'), ('os_010', 'Disk_wr_ios'), ('os_010', 'Disk_wr_kbs'), ('os_010', 'Incoming_network_traffic'), ('os_010', 'Memory_available'), ('os_010', 'Memory_available_pct'), ('os_010', 'Memory_used'), ('os_010', 'Memory_used_pct'), ('os_010', 'Outgoing_network_traffic'), ('os_010', 'Page_pi'), ('os_010', 'Page_po'), ('os_010', 'Processor_load_15_min'), ('os_010', 'Processor_load_1_min'), ('os_010', 'Processor_load_5_min'), ('os_010', 'Recv_total'), ('os_010', 'Send_total'), ('os_010', 'ss_total'), ('os_011', 'CPU_idle_pct'), ('os_011', 'CPU_iowait_time'), ('os_011', 'CPU_system_time'), ('os_011', 'CPU_user_time'), ('os_011', 'CPU_util_pct'), ('os_011', 'Disk_avgqu_sz'), ('os_011', 'Disk_await'), ('os_011', 'Disk_io_util'), ('os_011', 'Disk_rd_ios'), ('os_011', 'Disk_rd_kbs'), ('os_011', 'Disk_svctm'), ('os_011', 'Disk_wr_ios'), ('os_011', 'Disk_wr_kbs'), ('os_011', 'Incoming_network_traffic'), ('os_011', 'Memory_available'), ('os_011', 'Memory_available_pct'), ('os_011', 'Memory_used'), ('os_011', 'Memory_used_pct'), ('os_011', 'Outgoing_network_traffic'), ('os_011', 'Page_pi'), ('os_011', 'Page_po'), ('os_011', 'Processor_load_15_min'), ('os_011', 'Processor_load_1_min'), ('os_011', 'Processor_load_5_min'), ('os_011', 'Recv_total'), ('os_011', 'Send_total'), ('os_011', 'ss_total'), ('os_012', 'CPU_idle_pct'), ('os_012', 'CPU_iowait_time'), ('os_012', 'CPU_system_time'), ('os_012', 'CPU_user_time'), ('os_012', 'CPU_util_pct'), ('os_012', 'Disk_avgqu_sz'), ('os_012', 'Disk_await'), ('os_012', 'Disk_io_util'), ('os_012', 'Disk_rd_ios'), ('os_012', 'Disk_rd_kbs'), ('os_012', 'Disk_svctm'), ('os_012', 'Disk_wr_ios'), ('os_012', 'Disk_wr_kbs'), ('os_012', 'Incoming_network_traffic'), ('os_012', 'Memory_available'), ('os_012', 'Memory_available_pct'), ('os_012', 'Memory_used'), ('os_012', 'Memory_used_pct'), ('os_012', 'Outgoing_network_traffic'), ('os_012', 'Page_pi'), ('os_012', 'Page_po'), ('os_012', 'Processor_load_15_min'), ('os_012', 'Processor_load_1_min'), ('os_012', 'Processor_load_5_min'), ('os_012', 'Recv_total'), ('os_012', 'Send_total'), ('os_012', 'ss_total'), ('os_013', 'CPU_idle_pct'), ('os_013', 'CPU_iowait_time'), ('os_013', 'CPU_system_time'), ('os_013', 'CPU_user_time'), ('os_013', 'CPU_util_pct'), ('os_013', 'Disk_avgqu_sz'), ('os_013', 'Disk_await'), ('os_013', 'Disk_io_util'), ('os_013', 'Disk_rd_ios'), ('os_013', 'Disk_rd_kbs'), ('os_013', 'Disk_svctm'), ('os_013', 'Disk_wr_ios'), ('os_013', 'Disk_wr_kbs'), ('os_013', 'Incoming_network_traffic'), ('os_013', 'Memory_available'), ('os_013', 'Memory_available_pct'), ('os_013', 'Memory_used'), ('os_013', 'Memory_used_pct'), ('os_013', 'Outgoing_network_traffic'), ('os_013', 'Page_pi'), ('os_013', 'Page_po'), ('os_013', 'Processor_load_15_min'), ('os_013', 'Processor_load_1_min'), ('os_013', 'Processor_load_5_min'), ('os_013', 'Recv_total'), ('os_013', 'Send_total'), ('os_013', 'ss_total'), ('os_014', 'CPU_idle_pct'), ('os_014', 'CPU_iowait_time'), ('os_014', 'CPU_system_time'), ('os_014', 'CPU_user_time'), ('os_014', 'CPU_util_pct'), ('os_014', 'Disk_avgqu_sz'), ('os_014', 'Disk_await'), ('os_014', 'Disk_io_util'), ('os_014', 'Disk_rd_ios'), ('os_014', 'Disk_rd_kbs'), ('os_014', 'Disk_svctm'), ('os_014', 'Disk_wr_ios'), ('os_014', 'Disk_wr_kbs'), ('os_014', 'Incoming_network_traffic'), ('os_014', 'Memory_available'), ('os_014', 'Memory_available_pct'), ('os_014', 'Memory_used'), ('os_014', 'Memory_used_pct'), ('os_014', 'Outgoing_network_traffic'), ('os_014', 'Page_pi'), ('os_014', 'Page_po'), ('os_014', 'Processor_load_15_min'), ('os_014', 'Processor_load_1_min'), ('os_014', 'Processor_load_5_min'), ('os_014', 'Recv_total'), ('os_014', 'Send_total'), ('os_014', 'ss_total'), ('os_015', 'CPU_idle_pct'), ('os_015', 'CPU_iowait_time'), ('os_015', 'CPU_system_time'), ('os_015', 'CPU_user_time'), ('os_015', 'CPU_util_pct'), ('os_015', 'Disk_avgqu_sz'), ('os_015', 'Disk_await'), ('os_015', 'Disk_io_util'), ('os_015', 'Disk_rd_ios'), ('os_015', 'Disk_rd_kbs'), ('os_015', 'Disk_svctm'), ('os_015', 'Disk_wr_ios'), ('os_015', 'Disk_wr_kbs'), ('os_015', 'Incoming_network_traffic'), ('os_015', 'Memory_available'), ('os_015', 'Memory_available_pct'), ('os_015', 'Memory_used'), ('os_015', 'Memory_used_pct'), ('os_015', 'Outgoing_network_traffic'), ('os_015', 'Page_pi'), ('os_015', 'Page_po'), ('os_015', 'Processor_load_15_min'), ('os_015', 'Processor_load_1_min'), ('os_015', 'Processor_load_5_min'), ('os_015', 'Recv_total'), ('os_015', 'Send_total'), ('os_015', 'ss_total'), ('os_016', 'CPU_idle_pct'), ('os_016', 'CPU_iowait_time'), ('os_016', 'CPU_system_time'), ('os_016', 'CPU_user_time'), ('os_016', 'CPU_util_pct'), ('os_016', 'Disk_avgqu_sz'), ('os_016', 'Disk_await'), ('os_016', 'Disk_io_util'), ('os_016', 'Disk_rd_ios'), ('os_016', 'Disk_rd_kbs'), ('os_016', 'Disk_svctm'), ('os_016', 'Disk_wr_ios'), ('os_016', 'Disk_wr_kbs'), ('os_016', 'Incoming_network_traffic'), ('os_016', 'Memory_available'), ('os_016', 'Memory_available_pct'), ('os_016', 'Memory_used'), ('os_016', 'Memory_used_pct'), ('os_016', 'Outgoing_network_traffic'), ('os_016', 'Page_pi'), ('os_016', 'Page_po'), ('os_016', 'Processor_load_15_min'), ('os_016', 'Processor_load_1_min'), ('os_016', 'Processor_load_5_min'), ('os_016', 'Recv_total'), ('os_016', 'Send_total'), ('os_016', 'ss_total'), ('os_017', 'CPU_idle_pct'), ('os_017', 'CPU_iowait_time'), ('os_017', 'CPU_system_time'), ('os_017', 'CPU_user_time'), ('os_017', 'CPU_util_pct'), ('os_017', 'Disk_avgqu_sz'), ('os_017', 'Disk_await'), ('os_017', 'Disk_io_util'), ('os_017', 'Disk_rd_ios'), ('os_017', 'Disk_rd_kbs'), ('os_017', 'Disk_svctm'), ('os_017', 'Disk_wr_ios'), ('os_017', 'Disk_wr_kbs'), ('os_017', 'Incoming_network_traffic'), ('os_017', 'Memory_available'), ('os_017', 'Memory_available_pct'), ('os_017', 'Memory_used'), ('os_017', 'Memory_used_pct'), ('os_017', 'Outgoing_network_traffic'), ('os_017', 'Page_pi'), ('os_017', 'Page_po'), ('os_017', 'Processor_load_15_min'), ('os_017', 'Processor_load_1_min'), ('os_017', 'Processor_load_5_min'), ('os_017', 'Recv_total'), ('os_017', 'Send_total'), ('os_017', 'ss_total'), ('os_018', 'CPU_idle_pct'), ('os_018', 'CPU_iowait_time'), ('os_018', 'CPU_system_time'), ('os_018', 'CPU_user_time'), ('os_018', 'CPU_util_pct'), ('os_018', 'Disk_avgqu_sz'), ('os_018', 'Disk_await'), ('os_018', 'Disk_io_util'), ('os_018', 'Disk_rd_ios'), ('os_018', 'Disk_rd_kbs'), ('os_018', 'Disk_svctm'), ('os_018', 'Disk_wr_ios'), ('os_018', 'Disk_wr_kbs'), ('os_018', 'Incoming_network_traffic'), ('os_018', 'Memory_available'), ('os_018', 'Memory_available_pct'), ('os_018', 'Memory_used'), ('os_018', 'Memory_used_pct'), ('os_018', 'Outgoing_network_traffic'), ('os_018', 'Page_pi'), ('os_018', 'Page_po'), ('os_018', 'Processor_load_15_min'), ('os_018', 'Processor_load_1_min'), ('os_018', 'Processor_load_5_min'), ('os_018', 'Recv_total'), ('os_018', 'Send_total'), ('os_018', 'ss_total'), ('os_019', 'CPU_idle_pct'), ('os_019', 'CPU_iowait_time'), ('os_019', 'CPU_system_time'), ('os_019', 'CPU_user_time'), ('os_019', 'CPU_util_pct'), ('os_019', 'Disk_avgqu_sz'), ('os_019', 'Disk_await'), ('os_019', 'Disk_io_util'), ('os_019', 'Disk_rd_ios'), ('os_019', 'Disk_rd_kbs'), ('os_019', 'Disk_svctm'), ('os_019', 'Disk_wr_ios'), ('os_019', 'Disk_wr_kbs'), ('os_019', 'Incoming_network_traffic'), ('os_019', 'Memory_available'), ('os_019', 'Memory_available_pct'), ('os_019', 'Memory_used'), ('os_019', 'Memory_used_pct'), ('os_019', 'Outgoing_network_traffic'), ('os_019', 'Page_pi'), ('os_019', 'Page_po'), ('os_019', 'Processor_load_15_min'), ('os_019', 'Processor_load_1_min'), ('os_019', 'Processor_load_5_min'), ('os_019', 'Recv_total'), ('os_019', 'Send_total'), ('os_019', 'ss_total'), ('os_020', 'CPU_idle_pct'), ('os_020', 'CPU_iowait_time'), ('os_020', 'CPU_system_time'), ('os_020', 'CPU_user_time'), ('os_020', 'CPU_util_pct'), ('os_020', 'Disk_avgqu_sz'), ('os_020', 'Disk_await'), ('os_020', 'Disk_io_util'), ('os_020', 'Disk_rd_ios'), ('os_020', 'Disk_rd_kbs'), ('os_020', 'Disk_svctm'), ('os_020', 'Disk_wr_ios'), ('os_020', 'Disk_wr_kbs'), ('os_020', 'Incoming_network_traffic'), ('os_020', 'Memory_available'), ('os_020', 'Memory_available_pct'), ('os_020', 'Memory_used'), ('os_020', 'Memory_used_pct'), ('os_020', 'Outgoing_network_traffic'), ('os_020', 'Page_pi'), ('os_020', 'Page_po'), ('os_020', 'Processor_load_15_min'), ('os_020', 'Processor_load_1_min'), ('os_020', 'Processor_load_5_min'), ('os_020', 'Recv_total'), ('os_020', 'Send_total'), ('os_020', 'ss_total'), ('os_021', 'CPU_idle_pct'), ('os_021', 'CPU_iowait_time'), ('os_021', 'CPU_system_time'), ('os_021', 'CPU_user_time'), ('os_021', 'CPU_util_pct'), ('os_021', 'Disk_avgqu_sz'), ('os_021', 'Disk_await'), ('os_021', 'Disk_io_util'), ('os_021', 'Disk_rd_ios'), ('os_021', 'Disk_rd_kbs'), ('os_021', 'Disk_svctm'), ('os_021', 'Disk_wr_ios'), ('os_021', 'Disk_wr_kbs'), ('os_021', 'Incoming_network_traffic'), ('os_021', 'Memory_available'), ('os_021', 'Memory_available_pct'), ('os_021', 'Memory_used'), ('os_021', 'Memory_used_pct'), ('os_021', 'Outgoing_network_traffic'), ('os_021', 'Page_pi'), ('os_021', 'Page_po'), ('os_021', 'Processor_load_15_min'), ('os_021', 'Processor_load_1_min'), ('os_021', 'Processor_load_5_min'), ('os_021', 'Recv_total'), ('os_021', 'Send_total'), ('os_021', 'ss_total'), ('os_022', 'CPU_idle_pct'), ('os_022', 'CPU_iowait_time'), ('os_022', 'CPU_system_time'), ('os_022', 'CPU_user_time'), ('os_022', 'CPU_util_pct'), ('os_022', 'Disk_avgqu_sz'), ('os_022', 'Disk_await'), ('os_022', 'Disk_io_util'), ('os_022', 'Disk_rd_ios'), ('os_022', 'Disk_rd_kbs'), ('os_022', 'Disk_svctm'), ('os_022', 'Disk_wr_ios'), ('os_022', 'Disk_wr_kbs'), ('os_022', 'Incoming_network_traffic'), ('os_022', 'Memory_available'), ('os_022', 'Memory_available_pct'), ('os_022', 'Memory_used'), ('os_022', 'Memory_used_pct'), ('os_022', 'Outgoing_network_traffic'), ('os_022', 'Page_pi'), ('os_022', 'Page_po'), ('os_022', 'Processor_load_15_min'), ('os_022', 'Processor_load_1_min'), ('os_022', 'Processor_load_5_min'), ('os_022', 'Recv_total'), ('os_022', 'Send_total'), ('os_022', 'ss_total'), ('redis_001', 'Redis_key_count'), ('redis_001', 'connected_clients'), ('redis_001', 'expired_keys'), ('redis_001', 'instantaneous_input_kbps'), ('redis_001', 'instantaneous_ops_per_sec'), ('redis_001', 'instantaneous_output_kbps'), ('redis_001', 'keyspace_hits'), ('redis_001', 'keyspace_misses'), ('redis_001', 'mem_fragmentation_ratio'), ('redis_001', 'total_commands_processed'), ('redis_001', 'total_connections_received'), ('redis_001', 'used_cpu_sys'), ('redis_001', 'used_cpu_user'), ('redis_001', 'used_memory'), ('redis_001', 'used_memory_peak'), ('redis_001', 'used_memory_rss'), ('redis_002', 'Redis_key_count'), ('redis_002', 'connected_clients'), ('redis_002', 'expired_keys'), ('redis_002', 'instantaneous_input_kbps'), ('redis_002', 'instantaneous_ops_per_sec'), ('redis_002', 'instantaneous_output_kbps'), ('redis_002', 'keyspace_hits'), ('redis_002', 'keyspace_misses'), ('redis_002', 'mem_fragmentation_ratio'), ('redis_002', 'total_commands_processed'), ('redis_002', 'total_connections_received'), ('redis_002', 'used_cpu_sys'), ('redis_002', 'used_cpu_user'), ('redis_002', 'used_memory'), ('redis_002', 'used_memory_peak'), ('redis_002', 'used_memory_rss'), ('redis_003', 'Redis_key_count'), ('redis_003', 'connected_clients'), ('redis_003', 'expired_keys'), ('redis_003', 'instantaneous_input_kbps'), ('redis_003', 'instantaneous_ops_per_sec'), ('redis_003', 'instantaneous_output_kbps'), ('redis_003', 'keyspace_hits'), ('redis_003', 'keyspace_misses'), ('redis_003', 'mem_fragmentation_ratio'), ('redis_003', 'total_commands_processed'), ('redis_003', 'total_connections_received'), ('redis_003', 'used_cpu_sys'), ('redis_003', 'used_cpu_user'), ('redis_003', 'used_memory'), ('redis_003', 'used_memory_peak'), ('redis_003', 'used_memory_rss'), ('redis_004', 'Redis_key_count'), ('redis_004', 'connected_clients'), ('redis_004', 'expired_keys'), ('redis_004', 'instantaneous_input_kbps'), ('redis_004', 'instantaneous_ops_per_sec'), ('redis_004', 'instantaneous_output_kbps'), ('redis_004', 'keyspace_hits'), ('redis_004', 'keyspace_misses'), ('redis_004', 'mem_fragmentation_ratio'), ('redis_004', 'total_commands_processed'), ('redis_004', 'total_connections_received'), ('redis_004', 'used_cpu_sys'), ('redis_004', 'used_cpu_user'), ('redis_004', 'used_memory'), ('redis_004', 'used_memory_peak'), ('redis_004', 'used_memory_rss'), ('redis_005', 'Redis_key_count'), ('redis_005', 'connected_clients'), ('redis_005', 'expired_keys'), ('redis_005', 'instantaneous_input_kbps'), ('redis_005', 'instantaneous_ops_per_sec'), ('redis_005', 'instantaneous_output_kbps'), ('redis_005', 'keyspace_hits'), ('redis_005', 'keyspace_misses'), ('redis_005', 'mem_fragmentation_ratio'), ('redis_005', 'total_commands_processed'), ('redis_005', 'total_connections_received'), ('redis_005', 'used_cpu_sys'), ('redis_005', 'used_cpu_user'), ('redis_005', 'used_memory'), ('redis_005', 'used_memory_peak'), ('redis_005', 'used_memory_rss'), ('redis_006', 'Redis_key_count'), ('redis_006', 'connected_clients'), ('redis_006', 'expired_keys'), ('redis_006', 'instantaneous_input_kbps'), ('redis_006', 'instantaneous_ops_per_sec'), ('redis_006', 'instantaneous_output_kbps'), ('redis_006', 'keyspace_hits'), ('redis_006', 'keyspace_misses'), ('redis_006', 'mem_fragmentation_ratio'), ('redis_006', 'total_commands_processed'), ('redis_006', 'total_connections_received'), ('redis_006', 'used_cpu_sys'), ('redis_006', 'used_cpu_user'), ('redis_006', 'used_memory'), ('redis_006', 'used_memory_peak'), ('redis_006', 'used_memory_rss'), ('redis_007', 'Redis_key_count'), ('redis_007', 'connected_clients'), ('redis_007', 'expired_keys'), ('redis_007', 'instantaneous_input_kbps'), ('redis_007', 'instantaneous_ops_per_sec'), ('redis_007', 'instantaneous_output_kbps'), ('redis_007', 'keyspace_hits'), ('redis_007', 'keyspace_misses'), ('redis_007', 'mem_fragmentation_ratio'), ('redis_007', 'total_commands_processed'), ('redis_007', 'total_connections_received'), ('redis_007', 'used_cpu_sys'), ('redis_007', 'used_cpu_user'), ('redis_007', 'used_memory'), ('redis_007', 'used_memory_peak'), ('redis_007', 'used_memory_rss'), ('redis_008', 'Redis_key_count'), ('redis_008', 'connected_clients'), ('redis_008', 'expired_keys'), ('redis_008', 'instantaneous_input_kbps'), ('redis_008', 'instantaneous_ops_per_sec'), ('redis_008', 'instantaneous_output_kbps'), ('redis_008', 'keyspace_hits'), ('redis_008', 'keyspace_misses'), ('redis_008', 'mem_fragmentation_ratio'), ('redis_008', 'total_commands_processed'), ('redis_008', 'total_connections_received'), ('redis_008', 'used_cpu_sys'), ('redis_008', 'used_cpu_user'), ('redis_008', 'used_memory'), ('redis_008', 'used_memory_peak'), ('redis_008', 'used_memory_rss'), ('redis_009', 'Redis_key_count'), ('redis_009', 'connected_clients'), ('redis_009', 'expired_keys'), ('redis_009', 'instantaneous_input_kbps'), ('redis_009', 'instantaneous_ops_per_sec'), ('redis_009', 'instantaneous_output_kbps'), ('redis_009', 'keyspace_hits'), ('redis_009', 'keyspace_misses'), ('redis_009', 'mem_fragmentation_ratio'), ('redis_009', 'total_commands_processed'), ('redis_009', 'total_connections_received'), ('redis_009', 'used_cpu_sys'), ('redis_009', 'used_cpu_user'), ('redis_009', 'used_memory'), ('redis_009', 'used_memory_peak'), ('redis_009', 'used_memory_rss'), ('redis_010', 'Redis_key_count'), ('redis_010', 'connected_clients'), ('redis_010', 'expired_keys'), ('redis_010', 'instantaneous_input_kbps'), ('redis_010', 'instantaneous_ops_per_sec'), ('redis_010', 'instantaneous_output_kbps'), ('redis_010', 'keyspace_hits'), ('redis_010', 'keyspace_misses'), ('redis_010', 'mem_fragmentation_ratio'), ('redis_010', 'total_commands_processed'), ('redis_010', 'total_connections_received'), ('redis_010', 'used_cpu_sys'), ('redis_010', 'used_cpu_user'), ('redis_010', 'used_memory'), ('redis_010', 'used_memory_peak'), ('redis_010', 'used_memory_rss'), ('redis_011', 'Redis_key_count'), ('redis_011', 'connected_clients'), ('redis_011', 'expired_keys'), ('redis_011', 'instantaneous_input_kbps'), ('redis_011', 'instantaneous_ops_per_sec'), ('redis_011', 'instantaneous_output_kbps'), ('redis_011', 'keyspace_hits'), ('redis_011', 'keyspace_misses'), ('redis_011', 'mem_fragmentation_ratio'), ('redis_011', 'total_commands_processed'), ('redis_011', 'total_connections_received'), ('redis_011', 'used_cpu_sys'), ('redis_011', 'used_cpu_user'), ('redis_011', 'used_memory'), ('redis_011', 'used_memory_peak'), ('redis_011', 'used_memory_rss'), ('redis_012', 'Redis_key_count'), ('redis_012', 'connected_clients'), ('redis_012', 'expired_keys'), ('redis_012', 'instantaneous_input_kbps'), ('redis_012', 'instantaneous_ops_per_sec'), ('redis_012', 'instantaneous_output_kbps'), ('redis_012', 'keyspace_hits'), ('redis_012', 'keyspace_misses'), ('redis_012', 'mem_fragmentation_ratio'), ('redis_012', 'total_commands_processed'), ('redis_012', 'total_connections_received'), ('redis_012', 'used_cpu_sys'), ('redis_012', 'used_cpu_user'), ('redis_012', 'used_memory'), ('redis_012', 'used_memory_peak'), ('redis_012', 'used_memory_rss')]) dict_keys([('db_001', 'Asm_Free_Tb'), ('db_002', 'Asm_Free_Tb'), ('db_003', 'Asm_Free_Tb'), ('db_004', 'Asm_Free_Tb'), ('db_005', 'Asm_Free_Tb'), ('db_006', 'Asm_Free_Tb'), ('db_007', 'Asm_Free_Tb'), ('db_008', 'Asm_Free_Tb'), ('db_009', 'Asm_Free_Tb'), ('db_010', 'Asm_Free_Tb'), ('db_011', 'Asm_Free_Tb'), ('db_012', 'Asm_Free_Tb'), ('db_013', 'Asm_Free_Tb'), ('os_001', 'Buffers_used'), ('os_001', 'Cache_used'), ('os_001', 'FS_max_avail'), ('os_001', 'FS_max_util'), ('os_001', 'FS_total_space'), ('os_001', 'FS_used_pct'), ('os_001', 'FS_used_space'), ('os_001', 'Memory_free'), ('os_001', 'Num_of_processes'), ('os_001', 'Num_of_running_processes'), ('os_001', 'Received_packets'), ('os_001', 'Received_queue'), ('os_001', 'Sent_packets'), ('os_001', 'Sent_queue'), ('os_001', 'Shared_memory'), ('os_001', 'System_block_queue_length'), ('os_001', 'System_wait_queue_length'), ('os_001', 'Zombie_Process'), ('os_002', 'Buffers_used'), ('os_002', 'Cache_used'), ('os_002', 'FS_max_avail'), ('os_002', 'FS_max_util'), ('os_002', 'FS_total_space'), ('os_002', 'FS_used_pct'), ('os_002', 'FS_used_space'), ('os_002', 'Memory_free'), ('os_002', 'Num_of_processes'), ('os_002', 'Num_of_running_processes'), ('os_002', 'Received_packets'), ('os_002', 'Received_queue'), ('os_002', 'Sent_packets'), ('os_002', 'Sent_queue'), ('os_002', 'Shared_memory'), ('os_002', 'System_block_queue_length'), ('os_002', 'System_wait_queue_length'), ('os_002', 'Zombie_Process'), ('os_003', 'Buffers_used'), ('os_003', 'Cache_used'), ('os_003', 'FS_max_avail'), ('os_003', 'FS_max_util'), ('os_003', 'FS_total_space'), ('os_003', 'FS_used_pct'), ('os_003', 'FS_used_space'), ('os_003', 'Memory_free'), ('os_003', 'Num_of_processes'), ('os_003', 'Num_of_running_processes'), ('os_003', 'Received_packets'), ('os_003', 'Received_queue'), ('os_003', 'Sent_packets'), ('os_003', 'Sent_queue'), ('os_003', 'Shared_memory'), ('os_003', 'System_block_queue_length'), ('os_003', 'System_wait_queue_length'), ('os_003', 'Zombie_Process'), ('os_004', 'Buffers_used'), ('os_004', 'Cache_used'), ('os_004', 'FS_max_avail'), ('os_004', 'FS_max_util'), ('os_004', 'FS_total_space'), ('os_004', 'FS_used_pct'), ('os_004', 'FS_used_space'), ('os_004', 'Memory_free'), ('os_004', 'Num_of_processes'), ('os_004', 'Num_of_running_processes'), ('os_004', 'Received_packets'), ('os_004', 'Received_queue'), ('os_004', 'Sent_packets'), ('os_004', 'Sent_queue'), ('os_004', 'Shared_memory'), ('os_004', 'System_block_queue_length'), ('os_004', 'System_wait_queue_length'), ('os_004', 'Zombie_Process'), ('os_005', 'Buffers_used'), ('os_005', 'Cache_used'), ('os_005', 'FS_max_avail'), ('os_005', 'FS_max_util'), ('os_005', 'FS_total_space'), ('os_005', 'FS_used_pct'), ('os_005', 'FS_used_space'), ('os_005', 'Memory_free'), ('os_005', 'Num_of_processes'), ('os_005', 'Num_of_running_processes'), ('os_005', 'Received_packets'), ('os_005', 'Received_queue'), ('os_005', 'Sent_packets'), ('os_005', 'Sent_queue'), ('os_005', 'Shared_memory'), ('os_005', 'System_block_queue_length'), ('os_005', 'System_wait_queue_length'), ('os_005', 'Zombie_Process'), ('os_006', 'Buffers_used'), ('os_006', 'Cache_used'), ('os_006', 'FS_max_avail'), ('os_006', 'FS_max_util'), ('os_006', 'FS_total_space'), ('os_006', 'FS_used_pct'), ('os_006', 'FS_used_space'), ('os_006', 'Memory_free'), ('os_006', 'Num_of_processes'), ('os_006', 'Num_of_running_processes'), ('os_006', 'Received_packets'), ('os_006', 'Received_queue'), ('os_006', 'Sent_packets'), ('os_006', 'Sent_queue'), ('os_006', 'Shared_memory'), ('os_006', 'System_block_queue_length'), ('os_006', 'System_wait_queue_length'), ('os_006', 'Zombie_Process'), ('os_007', 'Buffers_used'), ('os_007', 'Cache_used'), ('os_007', 'FS_max_avail'), ('os_007', 'FS_max_util'), ('os_007', 'FS_total_space'), ('os_007', 'FS_used_pct'), ('os_007', 'FS_used_space'), ('os_007', 'Memory_free'), ('os_007', 'Num_of_processes'), ('os_007', 'Num_of_running_processes'), ('os_007', 'Received_packets'), ('os_007', 'Received_queue'), ('os_007', 'Sent_packets'), ('os_007', 'Sent_queue'), ('os_007', 'Shared_memory'), ('os_007', 'System_block_queue_length'), ('os_007', 'System_wait_queue_length'), ('os_007', 'Zombie_Process'), ('os_008', 'Buffers_used'), ('os_008', 'Cache_used'), ('os_008', 'FS_max_avail'), ('os_008', 'FS_max_util'), ('os_008', 'FS_total_space'), ('os_008', 'FS_used_pct'), ('os_008', 'FS_used_space'), ('os_008', 'Memory_free'), ('os_008', 'Num_of_processes'), ('os_008', 'Num_of_running_processes'), ('os_008', 'Received_packets'), ('os_008', 'Received_queue'), ('os_008', 'Sent_packets'), ('os_008', 'Sent_queue'), ('os_008', 'Shared_memory'), ('os_008', 'System_block_queue_length'), ('os_008', 'System_wait_queue_length'), ('os_008', 'Zombie_Process'), ('os_009', 'Buffers_used'), ('os_009', 'Cache_used'), ('os_009', 'FS_max_avail'), ('os_009', 'FS_max_util'), ('os_009', 'FS_total_space'), ('os_009', 'FS_used_pct'), ('os_009', 'FS_used_space'), ('os_009', 'Memory_free'), ('os_009', 'Num_of_processes'), ('os_009', 'Num_of_running_processes'), ('os_009', 'Received_packets'), ('os_009', 'Received_queue'), ('os_009', 'Sent_packets'), ('os_009', 'Sent_queue'), ('os_009', 'Shared_memory'), ('os_009', 'System_block_queue_length'), ('os_009', 'System_wait_queue_length'), ('os_009', 'Zombie_Process'), ('os_010', 'Buffers_used'), ('os_010', 'Cache_used'), ('os_010', 'FS_max_avail'), ('os_010', 'FS_max_util'), ('os_010', 'FS_total_space'), ('os_010', 'FS_used_pct'), ('os_010', 'FS_used_space'), ('os_010', 'Memory_free'), ('os_010', 'Num_of_processes'), ('os_010', 'Num_of_running_processes'), ('os_010', 'Received_packets'), ('os_010', 'Received_queue'), ('os_010', 'Sent_packets'), ('os_010', 'Sent_queue'), ('os_010', 'Shared_memory'), ('os_010', 'System_block_queue_length'), ('os_010', 'System_wait_queue_length'), ('os_010', 'Zombie_Process'), ('os_011', 'Buffers_used'), ('os_011', 'Cache_used'), ('os_011', 'FS_max_avail'), ('os_011', 'FS_max_util'), ('os_011', 'FS_total_space'), ('os_011', 'FS_used_pct'), ('os_011', 'FS_used_space'), ('os_011', 'Memory_free'), ('os_011', 'Num_of_processes'), ('os_011', 'Num_of_running_processes'), ('os_011', 'Received_packets'), ('os_011', 'Received_queue'), ('os_011', 'Sent_packets'), ('os_011', 'Sent_queue'), ('os_011', 'Shared_memory'), ('os_011', 'System_block_queue_length'), ('os_011', 'System_wait_queue_length'), ('os_011', 'Zombie_Process'), ('os_012', 'Buffers_used'), ('os_012', 'Cache_used'), ('os_012', 'FS_max_avail'), ('os_012', 'FS_max_util'), ('os_012', 'FS_total_space'), ('os_012', 'FS_used_pct'), ('os_012', 'FS_used_space'), ('os_012', 'Memory_free'), ('os_012', 'Num_of_processes'), ('os_012', 'Num_of_running_processes'), ('os_012', 'Received_packets'), ('os_012', 'Received_queue'), ('os_012', 'Sent_packets'), ('os_012', 'Sent_queue'), ('os_012', 'Shared_memory'), ('os_012', 'System_block_queue_length'), ('os_012', 'System_wait_queue_length'), ('os_012', 'Zombie_Process'), ('os_013', 'Buffers_used'), ('os_013', 'Cache_used'), ('os_013', 'FS_max_avail'), ('os_013', 'FS_max_util'), ('os_013', 'FS_total_space'), ('os_013', 'FS_used_pct'), ('os_013', 'FS_used_space'), ('os_013', 'Memory_free'), ('os_013', 'Num_of_processes'), ('os_013', 'Num_of_running_processes'), ('os_013', 'Received_packets'), ('os_013', 'Received_queue'), ('os_013', 'Sent_packets'), ('os_013', 'Sent_queue'), ('os_013', 'Shared_memory'), ('os_013', 'System_block_queue_length'), ('os_013', 'System_wait_queue_length'), ('os_013', 'Zombie_Process'), ('os_014', 'Buffers_used'), ('os_014', 'Cache_used'), ('os_014', 'FS_max_avail'), ('os_014', 'FS_max_util'), ('os_014', 'FS_total_space'), ('os_014', 'FS_used_pct'), ('os_014', 'FS_used_space'), ('os_014', 'Memory_free'), ('os_014', 'Num_of_processes'), ('os_014', 'Num_of_running_processes'), ('os_014', 'Received_packets'), ('os_014', 'Received_queue'), ('os_014', 'Sent_packets'), ('os_014', 'Sent_queue'), ('os_014', 'Shared_memory'), ('os_014', 'System_block_queue_length'), ('os_014', 'System_wait_queue_length'), ('os_014', 'Zombie_Process'), ('os_015', 'Buffers_used'), ('os_015', 'Cache_used'), ('os_015', 'FS_max_avail'), ('os_015', 'FS_max_util'), ('os_015', 'FS_total_space'), ('os_015', 'FS_used_pct'), ('os_015', 'FS_used_space'), ('os_015', 'Memory_free'), ('os_015', 'Num_of_processes'), ('os_015', 'Num_of_running_processes'), ('os_015', 'Received_packets'), ('os_015', 'Received_queue'), ('os_015', 'Sent_packets'), ('os_015', 'Sent_queue'), ('os_015', 'Shared_memory'), ('os_015', 'System_block_queue_length'), ('os_015', 'System_wait_queue_length'), ('os_015', 'Zombie_Process'), ('os_016', 'Buffers_used'), ('os_016', 'Cache_used'), ('os_016', 'FS_max_avail'), ('os_016', 'FS_max_util'), ('os_016', 'FS_total_space'), ('os_016', 'FS_used_pct'), ('os_016', 'FS_used_space'), ('os_016', 'Memory_free'), ('os_016', 'Num_of_processes'), ('os_016', 'Num_of_running_processes'), ('os_016', 'Received_packets'), ('os_016', 'Received_queue'), ('os_016', 'Sent_packets'), ('os_016', 'Sent_queue'), ('os_016', 'Shared_memory'), ('os_016', 'System_block_queue_length'), ('os_016', 'System_wait_queue_length'), ('os_016', 'Zombie_Process'), ('os_017', 'Buffers_used'), ('os_017', 'Cache_used'), ('os_017', 'FS_max_avail'), ('os_017', 'FS_max_util'), ('os_017', 'FS_total_space'), ('os_017', 'FS_used_pct'), ('os_017', 'FS_used_space'), ('os_017', 'Memory_free'), ('os_017', 'Num_of_processes'), ('os_017', 'Num_of_running_processes'), ('os_017', 'Received_packets'), ('os_017', 'Received_queue'), ('os_017', 'Sent_packets'), ('os_017', 'Sent_queue'), ('os_017', 'Shared_memory'), ('os_017', 'System_block_queue_length'), ('os_017', 'System_wait_queue_length'), ('os_017', 'Zombie_Process'), ('os_018', 'Buffers_used'), ('os_018', 'Cache_used'), ('os_018', 'FS_max_avail'), ('os_018', 'FS_max_util'), ('os_018', 'FS_total_space'), ('os_018', 'FS_used_pct'), ('os_018', 'FS_used_space'), ('os_018', 'Memory_free'), ('os_018', 'Num_of_processes'), ('os_018', 'Num_of_running_processes'), ('os_018', 'Received_packets'), ('os_018', 'Received_queue'), ('os_018', 'Sent_packets'), ('os_018', 'Sent_queue'), ('os_018', 'Shared_memory'), ('os_018', 'System_block_queue_length'), ('os_018', 'System_wait_queue_length'), ('os_018', 'Zombie_Process'), ('os_019', 'Buffers_used'), ('os_019', 'Cache_used'), ('os_019', 'FS_max_avail'), ('os_019', 'FS_max_util'), ('os_019', 'FS_total_space'), ('os_019', 'FS_used_pct'), ('os_019', 'FS_used_space'), ('os_019', 'Memory_free'), ('os_019', 'Num_of_processes'), ('os_019', 'Num_of_running_processes'), ('os_019', 'Received_packets'), ('os_019', 'Received_queue'), ('os_019', 'Sent_packets'), ('os_019', 'Sent_queue'), ('os_019', 'Shared_memory'), ('os_019', 'System_block_queue_length'), ('os_019', 'System_wait_queue_length'), ('os_019', 'Zombie_Process'), ('os_020', 'Buffers_used'), ('os_020', 'Cache_used'), ('os_020', 'FS_max_avail'), ('os_020', 'FS_max_util'), ('os_020', 'FS_total_space'), ('os_020', 'FS_used_pct'), ('os_020', 'FS_used_space'), ('os_020', 'Memory_free'), ('os_020', 'Num_of_processes'), ('os_020', 'Num_of_running_processes'), ('os_020', 'Received_packets'), ('os_020', 'Received_queue'), ('os_020', 'Sent_packets'), ('os_020', 'Sent_queue'), ('os_020', 'Shared_memory'), ('os_020', 'System_block_queue_length'), ('os_020', 'System_wait_queue_length'), ('os_020', 'Zombie_Process'), ('os_021', 'Buffers_used'), ('os_021', 'Cache_used'), ('os_021', 'FS_max_avail'), ('os_021', 'FS_max_util'), ('os_021', 'FS_total_space'), ('os_021', 'FS_used_pct'), ('os_021', 'FS_used_space'), ('os_021', 'Memory_free'), ('os_021', 'Num_of_processes'), ('os_021', 'Num_of_running_processes'), ('os_021', 'Received_packets'), ('os_021', 'Received_queue'), ('os_021', 'Sent_packets'), ('os_021', 'Sent_queue'), ('os_021', 'Shared_memory'), ('os_021', 'System_block_queue_length'), ('os_021', 'System_wait_queue_length'), ('os_021', 'Zombie_Process'), ('os_022', 'Buffers_used'), ('os_022', 'Cache_used'), ('os_022', 'FS_max_avail'), ('os_022', 'FS_max_util'), ('os_022', 'FS_total_space'), ('os_022', 'FS_used_pct'), ('os_022', 'FS_used_space'), ('os_022', 'Memory_free'), ('os_022', 'Num_of_processes'), ('os_022', 'Num_of_running_processes'), ('os_022', 'Received_packets'), ('os_022', 'Received_queue'), ('os_022', 'Sent_packets'), ('os_022', 'Sent_queue'), ('os_022', 'Shared_memory'), ('os_022', 'System_block_queue_length'), ('os_022', 'System_wait_queue_length'), ('os_022', 'Zombie_Process')])\n"
     ]
    }
   ],
   "source": [
    "minute_kpis = dict(tuple(df1))\n",
    "minute5_kpis = dict(tuple(df5))\n",
    "print(minute_kpis.keys(), minute5_kpis.keys())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 127,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[1440, 1440, 1440, 1326, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1152, 1152, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1327, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1296, 1296, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1328, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1327, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1152, 1152, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1327, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 2016, 2016, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1328, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 2304, 2304, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1325, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 2304, 2304, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1325, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 2016, 2016, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1325, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1152, 1152, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1326, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1008, 1008, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1328, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1008, 1008, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1326, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1152, 1152, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1325, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1152, 1152, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1373, 1373, 1378, 1378, 1380, 1380, 1372, 1372, 1378, 1378, 1377, 1377, 1378, 1378, 1377, 1378, 1439, 1439, 1439, 1439, 1438, 1439, 1439, 4261, 1439, 1439, 1439, 1439, 1439, 1439, 1440, 1437, 1440, 1440, 1439, 1440, 1440, 1439, 1439, 1439, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1438, 1440, 1440, 4254, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1439, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1434, 1440, 1440, 5471, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1434, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1434, 1440, 1440, 5753, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1435, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1433, 1440, 1440, 5586, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1433, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1435, 1440, 1440, 2880, 1440, 1440, 1440, 1440, 1440, 4320, 1440, 1436, 1440, 1440, 4320, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1439, 1440, 1440, 2879, 1440, 1440, 1440, 1440, 1440, 4320, 1440, 1438, 1440, 1440, 4320, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1435, 1440, 1440, 2880, 1440, 1440, 1440, 1440, 1440, 4320, 1440, 1436, 1440, 1440, 4320, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1438, 1440, 1440, 4318, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1439, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1438, 1440, 1440, 5724, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1439, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1436, 1440, 1440, 2876, 1440, 1440, 1440, 1440, 1440, 4320, 1440, 1438, 1440, 1440, 4320, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1439, 1440, 1440, 2507, 1440, 1440, 1440, 1440, 1440, 4320, 1440, 1439, 1440, 1440, 4320, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1439, 1440, 1440, 2710, 1440, 1440, 1440, 1440, 1440, 4320, 1440, 1438, 1440, 1440, 4320, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1436, 1440, 1440, 2877, 1440, 1440, 1440, 1440, 1440, 4320, 1440, 1435, 1440, 1440, 4320, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1433, 1440, 1440, 2878, 1440, 1440, 1440, 1440, 1440, 4320, 1440, 1434, 1440, 1440, 4320, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1434, 1440, 1440, 2879, 1440, 1440, 1440, 1440, 1440, 4320, 1440, 1434, 1440, 1440, 4320, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1435, 1440, 1440, 4320, 1440, 1440, 1440, 1440, 1440, 4320, 1440, 1436, 1440, 1440, 4320, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1435, 1440, 1440, 4282, 1440, 1440, 1440, 1440, 1440, 4320, 1440, 1433, 1440, 1440, 4320, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1436, 1440, 1440, 4319, 1440, 1440, 1440, 1440, 1440, 4320, 1440, 1435, 1440, 1440, 4320, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1434, 1440, 1440, 4309, 1440, 1440, 1440, 1440, 1440, 4320, 1440, 1434, 1440, 1440, 4320, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1434, 1440, 1440, 5694, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1434, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1433, 1440, 1440, 5696, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1433, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1439, 1440, 1440, 1439, 1439, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1439, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440, 1440] ('redis_012', 'used_memory_peak')\n"
     ]
    }
   ],
   "source": [
    "val_arr = []\n",
    "val_ind = []\n",
    "for host, kpi in minute_kpis.keys():\n",
    "    val_arr.append(minute_kpis[(host, kpi)]['value'].values)\n",
    "    val_ind.append((host, kpi))\n",
    "\n",
    "print([len(x) for x in val_arr], val_ind[-2])    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}
